{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Selvbudgettering","Bilag 1 ","Bilag 2 ","Bilag 3","Makro mv."],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Selvbudgettering","index":0,"n_rows":306,"n_cols":10,"rows_kept":306,"cut":false,"hidden":false,"merged":[[172,1,172,7],[173,1,173,7],[62,1,62,7],[4,3,4,5]]}
[null,{"$f":"\"Selvbudgettering af tilskud og udligning \"&aar","v":"Selvbudgettering af tilskud og udligning 2026"}]
[null," "]
[null,null,"Indtast eget kommunenummer her :"]
[null,null,null," "]
[null,null,"Kommune:",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,2),\"Ugyldigt kommunenr. \")","v":"Ugyldigt kommunenr. "}]
[null,null,"Indtast kommunens budgettal i Tabel 1 cellerne: F24, F25 og F28"]
[]
[]
[]
[]
[null,null,null,{"$f":"\"Indenrigs-og Sundhedsministeriet \"","v":"Indenrigs-og Sundhedsministeriet "}]
[null,null,null,{"$f":"\"Selvbudgettering af tilskud og udligning \"&aar","v":"Selvbudgettering af tilskud og udligning 2026"}]
[null,null,null,{"$f":"\"for  (\"&TEXT(knr,0)&\")  \"&$D$5","v":"for  (0)  Ugyldigt kommunenr. "}]
[]
[null,null,null,{"$f":"\"Indenrigs-og Sundhedsministeriet \"","v":"Indenrigs-og Sundhedsministeriet "}]
[null,null,null,"Slotholmsgade 10-12"]
[null,null,null,"1216 København K"]
[]
[]
[]
[null,{"$f":"\"Tabel 1:  Budgetteringsforudsætninger  (\"&TEXT(knr,0)&\")  \"&$D$5","v":"Tabel 1:  Budgetteringsforudsætninger  (0)  Ugyldigt kommunenr. "}]
[null,null,null,null,null,"Egen"]
[null,null,null,null,null,"beregning"]
[null,{"$f":"\"1.01 Indkomstskat  \"&aar","v":"1.01 Indkomstskat  2026"}]
[null,{"$f":"\"1.02 Udskrivningsprocent \"&aar&\"  (xx,xx)\"","v":"1.02 Udskrivningsprocent 2026  (xx,xx)"}]
[null,{"$f":"\"1.03 Beregningsteknisk grundværdier vedr. øvrige ejendomme \"&aar","v":"1.03 Beregningsteknisk grundværdier vedr. øvrige ejendomme 2026"},null,null,null,{"$f":"+H184","v":"---------- "}]
[null,{"$f":"\"1.04 Beregningsteknisk grundværdier vedr. produktionsjord \"&aar","v":"1.04 Beregningsteknisk grundværdier vedr. produktionsjord 2026"},null,null,null,{"$f":"+H186","v":"---------- "}]
[null,{"$f":"\"1.05 Skønnet folketal pr. 1. januar \"&aar","v":"1.05 Skønnet folketal pr. 1. januar 2026"}]
[null,"Anm. pkt. 1.05 Bopælskommuneopgørelse"]
[null,null,null,null,null,null,"1.01, 1.02 og 1.05 indberettes til"]
[null,null,null,null,null,null,"Indenrigs-  og Sundhedsministeriet"]
[null,null,null,null,null,null,"på www.indtast.dk,i skemaet vedr."]
[null,null,null,null,null,null,"skatteoplysninger og valg af bud-"]
[null,null,null,null,null,null,"getteringsmetode i forbindelse "]
[null,null,null,null,null,null,{"$f":"+\"med budgetindberetningen for \"&aar","v":"med budgetindberetningen for 2026"}]
[]
[null,{"$f":"\"Tabel 2: Selvbudgetterede udligningsbeløb vedr. \"&aar","v":"Tabel 2: Selvbudgetterede udligningsbeløb vedr. 2026"}]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.80 grp. 001 Kommunal udligning"]
[null,null,"Udligning af beskatningsgrundlag (jf. B.08)",null,null,{"$f":"IF(ok_pp=1,+G206,\" \")","v":" "},{"$f":"IF(OK_P=1,+H206,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F43-G43,\" \")","v":" "}]
[null,null,"Tillæg for kommuner med lavt beskatningsgrundlag (jf. C.08)",null,null,{"$f":"IF(ok_pp=1,+G222,\" \")","v":" "},{"$f":"IF(OK_P=1,+H222,\"---------- \")","v":"---------- "}," "]
[null,null,"Tillæg for kommuner med højt beskatningsgrundlag (jf. D.08)",null,null,{"$f":"IF(ok_pp=1,+G238,\" \")","v":" "},{"$f":"IF(OK_P=1,+H238,\"---------- \")","v":"---------- "}," "]
[null,null,"Finansieringsandel af tillæg vedr. beskatningsgrundlag (jf. G.16)",null,null,{"$f":"IF(ok_pp=1,+G294,\" \")","v":" "},{"$f":"IF(OK_P=1,+H294,\"---------- \")","v":"---------- "}," "]
[null,null,"Korr. vedr. overudligning (jf. G.15)",null,null,{"$f":"IF(ok_pp=1,+G293,\" \")","v":" "},{"$f":"IF(OK_P=1,+H293,\"---------- \")","v":"---------- "}," "]
[null,null,"Udligning af udgiftsbehov (jf E.07)",null,null,{"$f":"IF(ok_pp=1,+G253,\" \")","v":" "},{"$f":"IF(OK_P=1,+H253,\"---------- \")","v":"---------- "}," "]
[null,null,"Tillæg for kommuner med højt udgiftsbehov (jf. F.07)",null,null,{"$f":"IF(ok_pp=1,+G268,\" \")","v":" "},{"$f":"IF(OK_P=1,+H268,\"---------- \")","v":"---------- "}," "]
[null,null,"Finansieringsandel af tillæg vedr. udgiftsbehov (jf. G.17)",null,null,{"$f":"IF(ok_pp=1,+G295,\" \")","v":" "},{"$f":"IF(OK_P=1,+H295,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F50-G50,\" \")","v":" "}]
[]
[null,"7.62.80 grp. 002 Statstilskud til kommuner"]
[null,null,"Statstilskud, ordinært  til kommuner (jf. G.11)",null,null,{"$f":"IF(ok_pp=1,+G289,\" \")","v":" "},{"$f":"IF(OK_P=1,+H289,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F53-G53,\" \")","v":" "}]
[null,null,"Statstilskud, betinget vedr. service (jf. G.12)",null,null,{"$f":"IF(ok_pp=1,+G290,\" \")","v":" "},{"$f":"IF(OK_P=1,+H290,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F54-G54,\" \")","v":" "}]
[null,null,"Statstilskud, betinget vedr. anlæg (jf. G.13)",null,null,{"$f":"IF(ok_pp=1,+G291,\" \")","v":" "},{"$f":"IF(OK_P=1,+H291,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F55-G55,\" \")","v":" "}]
[]
[null,"7.62.81 grp. 001 Udligning vedr. udlændinge "]
[null,null,"Samlet bidrag vedr. indv. og efterkommere (jf. G.14)",null,null,{"$f":"IF(ok_pp=1,+G292,\" \")","v":" "},{"$f":"IF(OK_P=1,+H292,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F58-G58,\" \")","v":" "}]
[]
[null,"Selvbudgetterede beløb i alt",null,null,null,{"$f":"IF(ok_pp=1,SUM(F43:F58),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G43:G58),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,SUM(H43:H59),\" \")","v":" "}]
[]
[]
[]
[null,{"$f":"\"TABEL 3: Konteringsoversigt \"&aar&\" (del I)  for:   (\"&TEXT(knr,0)&\")  \"&$D$5","v":"TABEL 3: Konteringsoversigt 2026 (del I)  for:   (0)  Ugyldigt kommunenr. "}]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"2.32.33 Færgedrift",null,null,null,{"$f":"IF(ok_pp=1,SUM(F70:F75),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G70:G75),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F69-G69,\" \")","v":" "}]
[null,null,"Tilskud til nedsat færgetakst for godstransport",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,37),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,37),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F70-G70,\" \")","v":" "}]
[null,null,"Tilskud til nedsat færgetakst for passagerbefordring",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,38),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,38),\"---------- \")","v":"---------- "}," "]
[null,null,"Momskompensation vedr. færgetakster for godstransport",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,39),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,39),\"---------- \")","v":"---------- "}," "]
[null,null,"Momskompensation vedr. færgetakster for passagerer",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,40),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,40),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til færgedrift",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,41),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,41),\"---------- \")","v":"---------- "}," "]
[null,null,"Omstillingsstøtte (færger)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,42),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,42),\"---------- \")","v":"---------- "}," "]
[null,"2.32.33 I alt",null,null,null,{"$f":"IF(ok_pp=1,+F69,\" \")","v":" "},{"$f":"IF(OK_P=1,+G69,\"---------- \")","v":"---------- "}," "]
[]
[]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.80 grp. 001 Kommunal udligning",null,null,null,{"$f":"IF(ok_pp=1,SUM(F84:F93),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G84:G93),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F83-G83,\" \")","v":" "}]
[null,null,"Udligning af beskatningsgrundlag (jf. B.08)",null,null,{"$f":"IF(ok_pp=1,+G206,\" \")","v":" "},{"$f":"IF(OK_P=1,+H206,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F84-G84,\" \")","v":" "}]
[null,null,"Tillæg for kommuner med lavt beskatningsgrundlag (jf. C.08)",null,null,{"$f":"IF(ok_pp=1,+G222,\" \")","v":" "},{"$f":"IF(OK_P=1,+H222,\"---------- \")","v":"---------- "}," "]
[null,null,"Tillæg for kommuner med højt beskatningsgrundlag (jf. D.08)",null,null,{"$f":"IF(ok_pp=1,+G238,\" \")","v":" "},{"$f":"IF(OK_P=1,+H238,\"---------- \")","v":"---------- "}," "]
[null,null,"Finansieringsandel af tillæg vedr. beskatningsgrundlag (jf. G.16)",null,null,{"$f":"IF(ok_pp=1,+G294,\" \")","v":" "},{"$f":"IF(OK_P=1,+H294,\"---------- \")","v":"---------- "}," "]
[null,null,"Overudligning",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,7),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,7),\"---------- \")","v":"---------- "}," "]
[null,null,"Korr. vedr. overudligning (jf. G.15)",null,null,{"$f":"IF(ok_pp=1,+G293,\" \")","v":" "},{"$f":"IF(OK_P=1,+H293,\"---------- \")","v":"---------- "}," "]
[null,null,"Udligning af udgiftsbehov (jf E.07)",null,null,{"$f":"IF(ok_pp=1,+G253,\" \")","v":" "},{"$f":"IF(OK_P=1,+H253,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F90-G90,\" \")","v":" "}]
[null,null,"Tillæg for kommuner med højt udgiftsbehov (jf. F.07)",null,null,{"$f":"IF(ok_pp=1,+G268,\" \")","v":" "},{"$f":"IF(OK_P=1,+H268,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F91-G91,\" \")","v":" "}]
[null,null,"Finansieringsandel af tillæg vedr. udgiftsbehov (jf. G.17)",null,null,{"$f":"IF(ok_pp=1,+G295,\" \")","v":" "},{"$f":"IF(OK_P=1,+H295,\"---------- \")","v":"---------- "}," "]
[null,null,"Særlig kompensation",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,12),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,12),\"---------- \")","v":"---------- "}," "]
[null,"7.62.80 grp. 002 Statstilskud til kommuner ",null,null,null,{"$f":"IF(ok_pp=1,SUM(F95:F99),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G95:G99),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F94-G94,\" \")","v":" "}]
[null,null,{"$f":"+\"Bloktilskud ordinært vedr. \"&aar&\" (jf. G.11)\"","v":"Bloktilskud ordinært vedr. 2026 (jf. G.11)"},null,null,{"$f":"IF(ok_pp=1,+G289,\" \")","v":" "},{"$f":"IF(OK_P=1,+H289,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F95-G95,\" \")","v":" "}]
[null,null,{"$f":"+\"Bloktilskud betinget vedr. service \"&aar&\" (jf. G.12)\"","v":"Bloktilskud betinget vedr. service 2026 (jf. G.12)"},null,null,{"$f":"IF(ok_pp=1,+G290,\" \")","v":" "},{"$f":"IF(OK_P=1,+H290,\"---------- \")","v":"---------- "}," "]
[null,null,{"$f":"+\"Bloktilskud betinget vedr. anlæg \"&aar&\" (jf. G.13)\"","v":"Bloktilskud betinget vedr. anlæg 2026 (jf. G.13)"},null,null,{"$f":"IF(ok_pp=1,+G291,\" \")","v":" "},{"$f":"IF(OK_P=1,+H291,\"---------- \")","v":"---------- "}," "]
[null,null,"Individuelt modregning sfa. skattestigninger 2022 til 2023 ",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,51),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,51),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F98-G98,\" \")","v":" "}]
[null,null,"Individuelt modregning sfa. skattestigninger 2023 til 2024 ",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,52),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,52),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F99-G99,\" \")","v":" "}]
[null,{"$f":"+\"7.62.80 grp. 010 Udligning af selskabsskat\"","v":"7.62.80 grp. 010 Udligning af selskabsskat"},null,null,null,{"$f":"IF(ok_pp=1,SUM(F101:F101),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G101:G101),\" ---------- \")","v":" ---------- "}," "]
[null,null,{"$f":"+\"Udligning af selskabsskat\"","v":"Udligning af selskabsskat"},null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,15),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,15),\"---------- \")","v":"---------- "}," "]
[null,{"$f":"+\"7.62.80 grp. 011 Udligning af dækningsafgifter (offentlige ejendomme)\"","v":"7.62.80 grp. 011 Udligning af dækningsafgifter (offentlige ejendomme)"},null,null,null,{"$f":"IF(ok_pp=1,SUM(F103:F103),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G103:G103),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F102-G102,\" \")","v":" "}]
[null,null,{"$f":"+\"Udligning af dækningsafgift af offentlige ejendomme\"","v":"Udligning af dækningsafgift af offentlige ejendomme"},null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,16),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,16),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F103-G103,\" \")","v":" "}]
[null,"7.62.80 I alt",null,null,null,{"$f":"IF(ok_pp=1,+F83+F94+F100+F102,\" \")","v":" "},{"$f":"IF(OK_P=1,+G83+G94+G100+G102,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F118-G118,\" \")","v":" "}]
[]
[]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.81 grp. 001 Udligning vedr. udlændinge i alt",null,null,null,{"$f":"IF(ok_pp=1,SUM(F112:F113),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G112:G113),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F111-G111,\" \")","v":" "}]
[null,null,"Samlet tilskud vedr. indvandrer og efterkommere",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,13),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,13),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F112-G112,\" \")","v":" "}]
[null,null,"Samlet bidrag vedr. indv. og efterkommere (jf. G.14)",null,null,{"$f":"IF(ok_pp=1,+G292,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,14),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F113-G113,\" \")","v":" "}]
[null,"7.61.81 I alt",null,null,null,{"$f":"IF(ok_pp=1,F111,\" \")","v":" "},{"$f":"IF(OK_P=1,G111,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F114-G114,\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,{"$f":"\"TABEL 3: Konteringsoversigt \"&aar&\" (del II)  for:   (\"&TEXT(knr,0)&\")  \"&$D$5","v":"TABEL 3: Konteringsoversigt 2026 (del II)  for:   (0)  Ugyldigt kommunenr. "}]
[]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt) ",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.86 grp. 001 Tilskud til vanskeligt stillede kommuner",null,null,null,{"$f":"IF(ok_pp=1,SUM(F127:F127),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G127:G127),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F126-G126,\" \")","v":" "}]
[null,null,"Tilskud til vanskeligt stillede kommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,33),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,33),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 002 Tilskud til Furesø Kommune",null,null,null,{"$f":"IF(ok_pp=1,SUM(F129:F129),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G129:G129),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til Furesø Kommune",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,32),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,32),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 004 Tilskud til Ø-kommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F131:F132),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G131:G132),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F130-G130,\" \")","v":" "}]
[null,null,"Tilskud til kommuner med mindre øer",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,35),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,35),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til kommuner på øer uden fast forbindelse",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,36),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,36),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 013 Tilskud til bedre kvalitet i dagtilbud",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F134:F134),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G134:G134),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F133-G133,\" \")","v":" "}]
[null,null,"Tilskud til bedre kvalitet i dagtilbud",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,22),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,22),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 014 Tilskud til generelt løft af ældreplejen",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F136:F136),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G136:G136),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til generelt løft af ældreplejen",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,23),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,23),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 015 Tilskud til styrket kvalitet i ældreplejen",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F138:F138),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G138:G138),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til styrket kvalitet i ældreplejen",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,24),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,24),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 019 Finansieringstilskud (Tilskud til styrkelse af kom. Likviditet)",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F140:F141),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G140:G141),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+SUM(H141:H141),\" \")","v":" "}]
[null,null,"Tilskud til styrkelse af kommunernes likviditet",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,20),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,20),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F140-G140,\" \")","v":" "}]
[null,null,"Ekstra likviditetstilskud",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,21),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,21),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 021 Individuelt tilskud vedr. skattenedsættelser ",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F143:F149),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G143:G149),\" ---------- \")","v":" ---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2022-2023 (økonomiaftale)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,44),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,44),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2024-2025 (økonomiaftale)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,45),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,45),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2021-2022 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,46),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,46),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F145-G145,\" \")","v":" "}]
[null,null,"Tilskud vedr. skattenedsættelse 2022-2023 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,47),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,47),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F146-G146,\" \")","v":" "}]
[null,null,"Tilskud vedr. skattenedsættelse 2023-2024 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,48),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,48),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2024-2025 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,49),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,49),\"---------- \")","v":"---------- "}," "]
[null,null,"Permanent tilskud vedr. skattenedsættelse 2020-2021 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,50),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,50),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F149-G149,\" \")","v":" "}]
[null,"7.62.86 grp. 022 Tilskud til kommuner med vanskelige vilkår",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F151:F151),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G151:G151),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til kommuner med vanskelige økonomiske vilkår",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,34),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,34),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 025 Tilskud til værdig ældrepleje",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F153:F153),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G153:G153),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F152-G152,\" \")","v":" "}]
[null,null,"Tilskud til værdig ældrepleje",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,25),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,25),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F153-G153,\" \")","v":" "}]
[null,"7.62.86 grp. 026 Tilskud til bekæmpelse af ensomhed",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F155:F155),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G155:G155),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F154-G154,\" \")","v":" "}]
[null,null,"Tilskud til bekæmpelse af ensomhed",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,26),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,26),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F155-G155,\" \")","v":" "}]
[null,"7.62.86 grp. 027 Tilskud til udsatte ø- og yder kommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F157:F157),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G157:G157),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F156-G156,\" \")","v":" "}]
[null,null,"Tilskud til udsatte ø- og yderkommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,27),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,27),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F157-G157,\" \")","v":" "}]
[null,"7.62.86 grp. 028 Tilskud til udsatte hovedstadskommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F159:F160),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G159:G160),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til udsatte hovedstadskommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,28),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,28),\" ---------- \")","v":" ---------- "}," "]
[null,null,"Bidrag vedr. udsatte hovedstadskommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,29),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,29),\" ---------- \")","v":" ---------- "}," "]
[null,"7.62.86 grp. 029 Tilskud til grænsenære kommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F162:F162),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G162:G162),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til grænsenære kommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,30),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,30),\" ---------- \")","v":" ---------- "}," "]
[null,"7.62.86 grp. 030 Tilskud vedr. høj kriminalitet i visse boligområder",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F164:F164),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G164:G164),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. høj kriminalitet i visse boligområder",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,31),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,31),\" ---------- \")","v":" ---------- "}," "]
[null,"7.62.86 grp. 035 Kompensation vedr. nettotab som følge af ændring af dækningsafgiften",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F166:F166),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G166:G166),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F165-G165,\" \")","v":" "}]
[null,null,"Kompensationstilskud vedr. nettotab sfa. ændring i dækningsafgiften",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,43),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,43),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F166-G166,\" \")","v":" "}]
[null,"7.62.86 I alt",null,null,null,{"$f":"IF(ok_pp=1,+F126+F128+F130+F133+F137+F135+F150+F139+F142+F154+F152+F156+F158+F161+F163+F165,\" \")","v":" "},{"$f":"IF(OK_P=1,+G126+G128+G130+G133+G137+G135+G150+G139+G142+G154+G152+G156+G158+G161+G163+G165,\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F167-G167,\" \")","v":" "}]
[]
[null,{"$f":"+\"7.62.80, 7.62.81 og 7.62.86 I alt, til afregning i \"&aar&\" (del I + del II)\"","v":"7.62.80, 7.62.81 og 7.62.86 I alt, til afregning i 2026 (del I + del II)"},null,null,null,{"$f":"IF(ok_pp=1,+F76++F104+F114+F167,\" \")","v":" "},{"$f":"IF(OK_P=1,+G76+G104+G114+G167,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F169-G169,\" \")","v":" "}]
[]
[]
[]
[null,"Beregningsvejledning"]
[]
[]
[null,{"$f":"\"Bilag A:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag A:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Beregningsvejledning til opgørelse af kommunens beskatningsgrundlag \"&aar","v":"Beregningsvejledning til opgørelse af kommunens beskatningsgrundlag 2026"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"A.01 Indkomstskat (jf. pkt 1.01)\"","v":"A.01 Indkomstskat (jf. pkt 1.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,+F24,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,4),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.02 Udskrivningsprocent \"&aar&\" (jf. pkt 1.02)\"","v":"A.02 Udskrivningsprocent 2026 (jf. pkt 1.02)"},null,null,null,null,{"$f":"IF(ok_pp=1,F25,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,3),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.03 Udskrivningsgrundlag \"&aar&\" (pkt. A.01/A.02) \"","v":"A.03 Udskrivningsgrundlag 2026 (pkt. A.01/A.02) "},null,null,null,null,{"$f":"IF(ok_pp=1,ROUND(+F24/(F25/100),0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,5),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.04a Beregningsteknisk grundværdier vedr. øvrige ejendomme jf. pkt 1.03\"","v":"A.04a Beregningsteknisk grundværdier vedr. øvrige ejendomme jf. pkt 1.03"},null,null,null,null,{"$f":"IF(ok_pp=1,F26,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,9),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.04b \"&TEXT(100*'Bilag 3'!D19,\"0,00\")&\" % af beregningstekniske grundværdier vedr. øvrige ejendomme (jf. A.04a)\"","v":"A.04b 9,81 % af beregningstekniske grundværdier vedr. øvrige ejendomme (jf. A.04a)"},null,null,null,null,{"$f":"IF(ok_pp=1,ROUND(('Bilag 3'!D19)*F26,0),\" \")","v":" "},{"$f":"IF(OK_P=1,  ROUND(('Bilag 3'!D19)*(VLOOKUP(knr,Bilagtab2,9)),0),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.05a Beregningsteknisk grundværdier vedr. produktionsjord. pkt 1.04\"","v":"A.05a Beregningsteknisk grundværdier vedr. produktionsjord. pkt 1.04"},null,null,null,null,{"$f":"IF(ok_pp=1,F27,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,10),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.05b \"&TEXT(100*'Bilag 3'!D17,\" 0,00\")&\" % af beregningstekniske grundværdier vedr. produktionsjord (jf. A.05a)\"","v":"A.05b  2,96 % af beregningstekniske grundværdier vedr. produktionsjord (jf. A.05a)"},null,null,null,null,{"$f":"IF(ok_pp=1,ROUND(('Bilag 3'!D17)*F27,0),\" \")","v":" "},{"$f":"IF(OK_P=1,  ROUND(('Bilag 3'!D17)*(VLOOKUP(knr,Bilagtab2,10)),0),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.06 Beskatningsgrundlag \"&aar&\" i 1.000 kr.  (A.03 + A.04b + A.05b)\"","v":"A.06 Beskatningsgrundlag 2026 i 1.000 kr.  (A.03 + A.04b + A.05b)"},null,null,null,null,{"$f":"IF(ok_pp=1,+G183+G185+G187,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,11),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.07 Folketal (jf. pkt. 1.05)\"","v":"A.07 Folketal (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.08 Beskatningsgrundlag i kr. pr. indb.  (A.06 / A.07)\"","v":"A.08 Beskatningsgrundlag i kr. pr. indb.  (A.06 / A.07)"},null,null,null,null,{"$f":"IF(ok_pp=1,G188/F28,\" \")","v":" "},{"$f":"IF(OK_P=1,H188/H189,\"---------- \")","v":"---------- "}]
[null,"Anm: A.03, A.04b og A.05b afrundes til nærmeste hele 1.000 kr.  Pkt. A.08 indgår uafrundet i udligningsberegningerne"]
[]
[]
[null,{"$f":"\"Bilag B:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag B:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Udligning af beskatningsgrundlag \"&aar","v":"Udligning af beskatningsgrundlag 2026"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"B.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08\"","v":"B.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08"},null,null,null,null,{"$f":"IF(ok_pp=1,+G190,\" \")","v":" "},{"$f":"IF(OK_P=1,+H190,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.02 Gennemsnitligt beskatningsgrundlag pr. indbygger\"","v":"B.02 Gennemsnitligt beskatningsgrundlag pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$20/'Bilag 3'!$C$23,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$20/'Bilag 3'!$C$23,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.03 Forskel (pkt. B.02 - B.01)\"","v":"B.03 Forskel (pkt. B.02 - B.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,+G200-G199,\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,+H200-H199,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.04 Skattetryksfaktor \"","v":"B.04 Skattetryksfaktor "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.05 Udligningsprocent \"","v":"B.05 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$27,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$27,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.06 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"B.06 Kommunens folketal 1.1.2026 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.07 Beregnet udligningsbeløb (B.03 x B.04 x B.05 x B.06) \"","v":"B.07 Beregnet udligningsbeløb (B.03 x B.04 x B.05 x B.06) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G201*G202*G203*G204,\" \")","v":" "},{"$f":"IF(OK_P=1,+H201*H202*H203*H204,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.08 12-Afrundet udligningsbeløb  \"","v":"B.08 12-Afrundet udligningsbeløb  "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G205/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,3),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. B.03 Indgår uafrundet i udligningsberegningen, Pkt. B.08 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag C:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag C:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Tillæg for kommuner med lavt beskatningsgrundlag \"&aar","v":"Tillæg for kommuner med lavt beskatningsgrundlag 2026"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"C.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08\"","v":"C.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08"},null,null,null,null,{"$f":"IF(ok_pp=1,+G190,\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,+H190,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.02 \"&TEXT(100*'Bilag 3'!D25,\"0,0\")&\" % af gennemsnitligt beskatningegrundlag pr. indbygger\"","v":"C.02 90,0 % af gennemsnitligt beskatningegrundlag pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$D$25 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$D$25 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.03 positiv forskel (pkt. B.02 - B.01)\"","v":"C.03 positiv forskel (pkt. B.02 - B.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,IF(+G216-G215>0,G216-G215,0),\" \")","v":" "},{"$f":"IF(OK_P=1,IF(+H216-H215>0,H216-H215,),\" ---------- \")","v":" ---------- "}]
[null,{"$f":"\"C.04 Skattetryksfaktor \"","v":"C.04 Skattetryksfaktor "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.05 Udligningsprocent \"","v":"C.05 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$28,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$28,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.06 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"C.06 Kommunens folketal 1.1.2026 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.07 Beregnet udligningsbeløb (C.03 x C.04 x C.05 x C.06) \"","v":"C.07 Beregnet udligningsbeløb (C.03 x C.04 x C.05 x C.06) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G217*G218*G219*G220,\" \")","v":" "},{"$f":"IF(OK_P=1,+H217*H218*H219*H220,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.08 12-Afrundet udligningsbeløb    \"","v":"C.08 12-Afrundet udligningsbeløb    "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G221/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,4),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. C.03 Indgår uafrundet i udligningsberegningen, Pkt. C.08 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag D:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag D:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Tillæg for kommuner med højt beskatningsgrundlag \"&aar","v":"Tillæg for kommuner med højt beskatningsgrundlag 2026"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"D.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08\"","v":"D.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08"},null,null,null,null,{"$f":"IF(ok_pp=1,+G190,\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,+H190,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.02 \"&TEXT(100*'Bilag 3'!D26,\"0,0\")&\" % af gennemsnitligt beskatningegrundlag pr. indbygger\"","v":"D.02 125,0 % af gennemsnitligt beskatningegrundlag pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$D$26 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$D$26 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.03 Negativ forskel (pkt. B.02 - B.01)\"","v":"D.03 Negativ forskel (pkt. B.02 - B.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,IF(+G232-G231<0,G232-G231,0),\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,IF(+H232-H231<0,H232-H231,),\" ---------- \")","v":" ---------- "}]
[null,{"$f":"\"D.04 Skattetryksfaktor \"","v":"D.04 Skattetryksfaktor "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.05 Udligningsprocent \"","v":"D.05 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$29,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$29,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.06 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"D.06 Kommunens folketal 1.1.2026 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.07 Beregnet udligningsbeløb (D.03 x D.04 x D.05 x D.06) \"","v":"D.07 Beregnet udligningsbeløb (D.03 x D.04 x D.05 x D.06) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G233*G234*G235*G236,\" \")","v":" "},{"$f":"IF(OK_P=1,+H233*H234*H235*H236,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.08 12-Afrundet udligningsbeløb    \"","v":"D.08 12-Afrundet udligningsbeløb    "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G237/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,5),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. D.03 Indgår uafrundet i udligningsberegningen, Pkt. D.08 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag E:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag E:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Udligning af udgiftsbehov \"&aar","v":"Udligning af udgiftsbehov 2026"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"E.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)\"","v":"E.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)"},null,null,null,null,{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.02 Gennemsnitligt udgifgtsbehov pr. indbygger\"","v":"E.02 Gennemsnitligt udgifgtsbehov pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$C$32  /    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$C$32/    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.03 Forskel (pkt. B.01 - B.02)\"","v":"E.03 Forskel (pkt. B.01 - B.02)"},null,null,null,null,{"$f":"IF(ok_pp=1,G247-G248,\"    ---------- \")","v":"    ---------- "},{"$f":"IF(OK_P=1,H247-H248,\"     ---------- \")","v":"     ---------- "}]
[null,{"$f":"\"E.04 Udligningsprocent \"","v":"E.04 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$35,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$35,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.05 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"E.05 Kommunens folketal 1.1.2026 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) \"","v":"E.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G249*G250*G251,\" \")","v":" "},{"$f":"IF(OK_P=1,+H249*H250*H251,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.07 12-Afrundet udligningsbeløb  \"","v":"E.07 12-Afrundet udligningsbeløb  "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G252/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,9),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. E.03 Indgår uafrundet i udligningsberegningen, Pkt. E.07 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag F:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag F:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Tillæg for kommuner med højt udgiftsbehov \"&aar","v":"Tillæg for kommuner med højt udgiftsbehov 2026"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"F.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)\"","v":"F.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)"},null,null,null,null,{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.02 Gennemsnitligt udgifgtsbehov pr. indbygger\"","v":"F.02 Gennemsnitligt udgifgtsbehov pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$C$32  /    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$C$32/    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.03 Positiv forskel (pkt. B.01 - B.02)\"","v":"F.03 Positiv forskel (pkt. B.01 - B.02)"},null,null,null,null,{"$f":"IF(ok_pp=1,IF(G262-G263>0,G262-G263,0),\"      ---------- \")","v":"      ---------- "},{"$f":"IF(OK_P=1,IF(H262-H263>0,H262-H263,0),\"           ---------- \")","v":"           ---------- "}]
[null,{"$f":"\"F.04 Udligningsprocent \"","v":"F.04 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$36,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$36,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.05 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"F.05 Kommunens folketal 1.1.2026 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) \"","v":"F.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G264*G265*G266,\" \")","v":" "},{"$f":"IF(OK_P=1,+H264*H265*H266,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.07 12-Afrundet udligningsbeløb  \"","v":"F.07 12-Afrundet udligningsbeløb  "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G267/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,10),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. F.03 Indgår uafrundet i udligningsberegningen, Pkt. F.07 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag G:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag G:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Finansieringsbidrag fordelt efter folketal (statstilskud, indvandrerbidrag mv.) \"&aar","v":"Finansieringsbidrag fordelt efter folketal (statstilskud, indvandrerbidrag mv.) 2026"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"G.01 Bloktilskud (ordinært) i \"&aar&\", der fordeles efter folketal \"","v":"G.01 Bloktilskud (ordinært) i 2026, der fordeles efter folketal "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$10,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$10,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.02 Bloktilskud (betinget vedr service ) i \"&aar&\", der fordeles efter folketal \"","v":"G.02 Bloktilskud (betinget vedr service ) i 2026, der fordeles efter folketal "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$11,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$11,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.03 Bloktilskud (betinget vedr anlæg) i \"&aar&\", der fordeles efter folketal \"","v":"G.03 Bloktilskud (betinget vedr anlæg) i 2026, der fordeles efter folketal "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$12,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$12,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.04 Bidragspulje til udligningsordn. indv. og efterkommere \"&aar","v":"G.04 Bidragspulje til udligningsordn. indv. og efterkommere 2026"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$38,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$38,\"---------- \")","v":"---------- "}]
[null,{"$f":"+\"G.05 Bidragspulje til korrektion vedr. overudligning \"&aar","v":"G.05 Bidragspulje til korrektion vedr. overudligning 2026"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$40,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$40,\"---------- \")","v":"---------- "}]
[null,{"$f":"+\"G.06 Finansiering af tillæg vedr. beskatningsgrundlag \"&aar","v":"G.06 Finansiering af tillæg vedr. beskatningsgrundlag 2026"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$41,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$41,\"---------- \")","v":"---------- "}]
[null,{"$f":"+\"G.07 Finansiering af tillæg vedr. udgiftsbehov  \"&aar","v":"G.07 Finansiering af tillæg vedr. udgiftsbehov  2026"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$42,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$42,\"---------- \")","v":"---------- "}]
[]
[null,{"$f":"\"G.08 Samlet folketal \"&aar&\" i hele landet \"","v":"G.08 Samlet folketal 2026 i hele landet "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$33,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$33,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.09 Kommunens folketal\"","v":"G.09 Kommunens folketal"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.10 Kommunens andel af samlet folketal (pkt. G.09/G.08)\"","v":"G.10 Kommunens andel af samlet folketal (pkt. G.09/G.08)"},null,null,null,null,{"$f":"IF(ok_pp=1,+G286/G285,\" \")","v":" "},{"$f":"IF(OK_P=1,+H286/H285,\"---------- \")","v":"---------- "}]
[]
[null,{"$f":"\"G.11 Kommunens andel af ordinært bloktilskud (E.01 x G.10)\"","v":"G.11 Kommunens andel af ordinært bloktilskud (E.01 x G.10)"},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND((G277*$G$287)/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,17),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.12 Kommunens andel af betinget bloktilskud (service) (G.02 x G.10)\"","v":"G.12 Kommunens andel af betinget bloktilskud (service) (G.02 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,18),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.13 Kommunens andel af betinget bloktilskud (anlæg) (G.03 x G.10)\"","v":"G.13 Kommunens andel af betinget bloktilskud (anlæg) (G.03 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,19),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.14 Kommunens bidrag vedr. indv. og efterkommere (G.04 x G.08)\"","v":"G.14 Kommunens bidrag vedr. indv. og efterkommere (G.04 x G.08)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,14),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.15 Kommunen korrektion vedr. overudligning (G.05 x G.10)\"","v":"G.15 Kommunen korrektion vedr. overudligning (G.05 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,8),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.16 Kommunens finansieringsandel af tillæg vedr. beskatningsgrundlag (G.06 x G.10)\"","v":"G.16 Kommunens finansieringsandel af tillæg vedr. beskatningsgrundlag (G.06 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,6),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.17 Kommunens finansieringsandel af tillæg vedr. udgiftsbehov (G.075 x G.10)\"","v":"G.17 Kommunens finansieringsandel af tillæg vedr. udgiftsbehov (G.075 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,11),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. G.10 Indgår uafrundet i udligningsberegningen, Pkt. G.11-G.17 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Bilag 1 ","index":1,"n_rows":115,"n_cols":54,"rows_kept":115,"cut":false,"hidden":false,"merged":[[0,19,0,30],[0,31,0,41],[0,43,0,53]]}
[{"$f":"\"Bilagstabel 1: Udligningsbeløb statsgaranti \"&aar","v":"Bilagstabel 1: Udligningsbeløb statsgaranti 2026"},null,null,null,null,null,"samle 1",null,null,null,null,null,null,"samle 2",null,null,null,"samle 3",null,"samle 4.1",null,null,null,null,null,null,null,null,null,null,null,"samle 4.2",null,null,null,null,null,null,null,null,null,null,null,"samle 4.3"]
[null,null,1,{"$f":"+C2+1","v":2},{"$f":"+D2+1","v":3},4,5,6,7,8,9,10,1,{"$f":"+M2+1","v":2},{"$f":"+N2+1","v":3},4,1,{"$f":"+Q2+1","v":2},{"$f":"+R2+1","v":3},1,{"$f":"+T2+1","v":2},{"$f":"+U2+1","v":3},4,5,6,7,8,9,10,11,12,1,{"$f":"+AF2+1","v":2},{"$f":"+AG2+1","v":3},{"$f":"+AH2+1","v":4},{"$f":"+AI2+1","v":5},{"$f":"+AJ2+1","v":6},{"$f":"+AK2+1","v":7},{"$f":"+AL2+1","v":8},{"$f":"+AM2+1","v":9},{"$f":"+AN2+1","v":10},{"$f":"+AO2+1","v":11},{"$f":"+AP2+1","v":12},1,{"$f":"+AR2+1","v":2},{"$f":"+AS2+1","v":3},{"$f":"+AT2+1","v":4},{"$f":"+AU2+1","v":5},{"$f":"+AV2+1","v":6},{"$f":"+AW2+1","v":7},{"$f":"+AX2+1","v":8},{"$f":"+AY2+1","v":9},{"$f":"+AZ2+1","v":10},11]
["knr","kommunenavn"," Udlig-"," Tillæg"," Tillæg"," Finan-"," Over-"," Korrek-"," Udlig-"," Tillæg"," Finan-"," Særlig"," Tilskud"," Bidrag"," Udlig-"," Udlig-"," Ordinært"," Betinget"," Betinget"," Finan-","Ekstra"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Bidrag"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Moms-"," Moms-"," Tilskud","Om-","Kompen-"," Indivi-"," Indivi-"," Midler-"," Midler-"," Midler-"," Midler-"," Per-"," Indivi-"," Indivi-"]
[null,null," ning"," for kom-"," for kom-"," siering"," udlig-"," tion"," ning"," for"," siering"," kom-"," vedr."," vedr."," ning"," ning"," blok-"," blok-"," blok-"," sierings-","finan-"," til"," til"," til"," til"," til"," til"," til"," til"," til"," vedr."," til"," til"," til kom-"," til"," til"," til"," til"," kompen-"," kompen-"," til","stil-","sations-"," duelle"," duelle"," tidigt"," tidigt"," tidigt"," tidigt"," manent"," duel"," duel","(tom)","(tom)"]
[null,null," af"," muner"," muner"," af"," ning"," vedr."," udgifts-"," kom-"," af"," pen-"," ind-"," ind-"," af"," af"," tilskud"," tilskud"," tilskud"," tilskud"," sierings-"," bedre"," generelt"," styrket"," værdig"," bekæm-"," udsatte"," udsatte"," udsatte"," grænse-"," høj"," Furesø"," vanske-"," muner"," kom-"," kom-"," nedsæt-"," nedsæt-"," sation"," sation","færge-","lings-","tilskud"," tilskud"," tilskud"," tilskud"," tilskud"," tilskud"," tilskud"," tilskud"," mod-"," mod-"]
[null,null," beskat-"," med"," med"," tillæg",null," over-"," behov"," muner"," tillæg"," sation"," vandrer"," vandrer"," sel-"," dæk-",null," vedr."," vedr.",null," tilskud"," kvalitet"," løft i"," kvalitet"," ældre-"," pelse"," ø-"," hoved-"," hoved-"," nære"," krimi-"," Kom-"," ligt"," med"," muner"," muner"," telse"," telse"," vedr."," vedr.","drift","støtte","vedr."," vedr."," vedr."," vedr."," vedr."," vedr."," vedr."," vedr."," regning"," regning"]
[null,null," nings-"," lavt"," højt"," vedr.",null," udlig-",null," med"," vedr.",null," og"," og"," skabs-"," nings-",null," service-"," anlæg",null,null," i dag-"," ældre-"," ældre-"," pleje"," af"," og"," stads-"," stads-"," kom-"," nalitet"," mune"," stillede"," vanske-"," med"," på øer"," af"," af"," færge-"," færge-",null,"(færger)","netto-"," skatte-"," skatte-"," skatte-"," skatte-"," skatte-"," skatte-"," skatte-"," sfa."," sfa."]
[null,null," grundlag"," beskat-"," beskat-"," beskat-",null," ning",null," højt"," udgifts-",null," efter-"," efter-"," skat"," afgift",null," udgifter",null,null,null," tilbud"," plejen"," pleje",null," ensom-"," yder-"," kom-"," kom-"," muner"," i visse",null," kom-"," lige"," mindre"," uden"," takster"," takster"," takster"," takster",null,null,"tab sfa."," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," skatte-"," skatte-"]
[null,null,null," nings-"," nings-"," nings-",null,null,null," udgifts-"," behov",null," kom-"," kom-",null,null,null,null,null,null,null,null,null,null,null," hed på"," kom-"," muner"," muner",null," bolig-",null," muner"," økono-"," øer"," fast"," for"," for"," for"," for",null,null,"ændring"," telser"," telser"," telser"," telser"," telser"," telser"," telser"," stig-"," stig-"]
[null,null,null," grundlag"," grundlag"," grundlag",null,null,null," behov",null,null," mere"," mere",null,null,null,null,null,null,null,null,null,null,null," ældre-"," muner",null,null,null," områder",null,null," miske",null," forbin-"," gods-"," passa-"," gods-"," passa-",null,null,"i dæk-","(ØA)","(ØA)","(Udl.ref)","(Udl.ref)","(Udl.ref)","(Udl.ref)","(Udl.ref)"," ninger"," ninger"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," området",null,null,null,null,null,null,null," vilkår",null," delse"," transport"," gerer mv."," transport"," gerer mv.",null,null,"nings-","2022-2023"," 2024-2025"," 2021-2022","2022-2023","2023-2024","2024-2025"," 2020-2021","2022-2023","2023-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"afgiften"]
[null,null,3,{"$f":"+C13+1","v":4},{"$f":"+D13+1","v":5},6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,{"$f":"+T13+1","v":21},{"$f":"+U13+1","v":22},{"$f":"+V13+1","v":23},{"$f":"+W13+1","v":24},{"$f":"+X13+1","v":25},{"$f":"+Y13+1","v":26},{"$f":"+Z13+1","v":27},{"$f":"+AA13+1","v":28},{"$f":"+AB13+1","v":29},{"$f":"+AC13+1","v":30},{"$f":"+AD13+1","v":31},{"$f":"+AE13+1","v":32},{"$f":"+AF13+1","v":33},{"$f":"+AG13+1","v":34},{"$f":"+AH13+1","v":35},{"$f":"+AI13+1","v":36},{"$f":"+AJ13+1","v":37},{"$f":"+AK13+1","v":38},{"$f":"+AL13+1","v":39},{"$f":"+AM13+1","v":40},{"$f":"+AN13+1","v":41},{"$f":"+AO13+1","v":42},{"$f":"+AP13+1","v":43},{"$f":"+AQ13+1","v":44},{"$f":"+AR13+1","v":45},{"$f":"+AS13+1","v":46},{"$f":"+AT13+1","v":47},{"$f":"+AU13+1","v":48},{"$f":"+AV13+1","v":49},{"$f":"+AW13+1","v":50},{"$f":"+AX13+1","v":51},{"$f":"+AY13+1","v":52},{"$f":"+AZ13+1","v":53},{"$f":"+BA13+1","v":54}]
[null,null,1,{"$f":"+C14+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52]
[]
[1,"Kommuner i alt",{"$f":"SUM(C18:C115)","v":0},471876,-1508340,1036464,303108,-303108,0,263124,-263124,0,3723756,-3723756,0,0,78347304,3000000,999996,3500004,1827996,670200,893100,1196604,1253304,119496,1769796,713400,-426696,117996,106296,37896,936,375696,140196,254904,45600,161508,9696,13404,2500,15804,433656,36240,{"$f":"SUM(AS18:AS115)","v":72252},24420,31836,68124,32508,{"$f":"SUM(AX18:AX115)","v":257544},-84000,-333492,0,0]
[]
[101,"København",-1920372,0,0,115812,0,-33864,-2969448,0,-29400,182604,551172,-416064,-829512,-19440,8754036,335196,111732,167604,51060,79788,49284,66036,69168,6588,0,0,-59736,29508,29532,0,0,0,0,0,0,0,0,0,0,0,0,32904,68724,0,0,68124,13752,0,0,0]
[147,"Frederiksberg",-1290624,0,-13296,18228,1368,-5328,-1016208,0,-4632,-24384,53688,-65496,58464,-1848,1378128,52764,17592,26388,8040,12012,13416,17976,18828,1800,0,0,-12420,0,0,0,0,0,0,0,0,0,0,0,0,0,10848,0,0,0,0,0,0,0,-37284,-134196]
[151,"Ballerup",-5124,0,0,9228,0,-2700,381024,8196,-2340,-11340,53808,-33156,-178116,-72,697560,26712,8904,28152,14220,6660,7872,10536,11040,1056,0,31944,-4944,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[153,"Brøndby",349824,41892,0,7116,0,-2076,592668,12744,-1800,47592,67104,-25548,-35328,192,537576,20580,6864,37392,21708,5412,5148,6888,7224,684,0,73860,-3084,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[155,"Dragør",-241488,0,-17724,2472,984,-720,-73656,0,-624,-3336,4044,-8892,13392,180,187056,7164,2388,3576,1092,1680,2760,3708,3876,372,0,0,-2268,0,0,0,0,0,0,0,0,0,0,0,0,0,252,0,0,0,0,0,0,0,0,0]
[157,"Gentofte",-4153800,0,-787248,12900,134520,-3768,-530244,0,-3276,-17568,49032,-46320,-249756,312,974688,37320,12444,18660,5688,7812,12132,16260,17028,1620,0,0,-114972,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3528,0,0,0,10572,0,0,0]
[159,"Gladsaxe",-356388,0,0,12264,0,-3588,114624,2460,-3120,-16404,87312,-44076,-457428,804,927336,35508,11832,17760,5412,8928,8748,11712,12276,1164,0,0,-7296,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[161,"Glostrup",22320,0,0,4320,0,-1260,107328,2304,-1092,-5304,31488,-15504,-12288,-960,326244,12492,4164,13164,6648,3144,3288,4392,4608,444,0,14940,-2256,4716,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9864,0]
[163,"Herlev",42780,0,0,5352,0,-1560,188892,4068,-1356,-6780,33804,-19236,8160,-1692,404760,15504,5160,16332,8244,3696,4284,5736,6000,576,0,37068,-2772,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[165,"Albertslund",136224,1236,0,4860,0,-1416,385860,8304,-1236,84192,36000,-17448,6348,276,366996,14052,4680,25524,14820,3120,3816,5112,5352,516,0,33612,-2400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[167,"Hvidovre",-1728,0,0,9276,0,-2712,276480,5940,-2352,33024,43836,-33336,8988,-216,701328,26856,8952,28308,14292,6588,6960,9324,9768,936,0,64236,-5040,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7284,0,0,0,0,0]
[169,"Høje-Taastrup",335436,14460,0,10380,0,-3036,237888,5112,-2640,132984,94572,-37284,-138300,528,784356,30036,10008,31656,15984,8232,6888,9228,9660,924,0,71844,-4620,0,5904,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[173,"Lyngby-Taarbæk",-1432668,0,-178704,10152,25380,-2976,-418980,0,-2580,-13068,46092,-36492,-44340,-2436,767700,29400,9804,14700,4476,6240,8484,11364,11904,1140,0,0,-23388,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[175,"Rødovre",90264,0,0,7812,0,-2280,252324,5424,-1980,18264,52236,-28080,40752,300,590844,22620,7536,23844,12036,5664,5880,7884,8256,792,0,54120,-3708,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[183,"Ishøj",195672,21624,0,4224,0,-1236,357480,7692,-1068,114948,42396,-15192,18636,252,319584,12240,4080,22224,12912,3048,2724,3660,3828,360,0,43908,-1836,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[185,"Tårnby",-53220,0,0,7620,0,-2232,119508,2568,-1932,840,25740,-27396,30048,540,576324,22068,7356,11040,3360,5196,5988,8028,8412,804,0,52788,-4260,11796,0,0,0,0,0,0,0,0,0,0,0,0,1068,0,0,0,0,0,0,0,0,-39924]
[187,"Vallensbæk",15624,0,0,3192,0,-936,-51960,0,-804,9024,30780,-11460,-3348,264,241056,9228,3072,4620,1404,2580,2328,3120,3264,312,0,0,-1632,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[190,"Furesø",-677292,0,-42708,7368,1668,-2160,-136476,0,-1872,-9696,28416,-26484,25488,564,557100,21336,7116,10668,3252,5604,7140,9576,10032,960,0,0,-5292,0,0,37896,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[201,"Allerød",-383604,0,-18996,4488,0,-1320,-224304,0,-1140,-6048,12516,-16140,-12672,204,339684,13008,4332,6504,1980,3252,4272,5724,5988,576,0,0,-3228,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-13296,0]
[210,"Fredensborg",-346320,0,0,7296,0,-2136,-32580,0,-1848,-9600,31092,-26220,33204,588,551640,21120,7044,10560,3216,5004,7236,9708,10164,972,0,0,-4692,0,0,0,0,0,0,0,0,0,0,0,0,0,216,0,0,0,0,0,0,0,0,0]
[217,"Helsingør",-383412,0,0,11040,0,-3228,104328,2244,-2808,-14688,28992,-39684,57708,648,834888,31968,10656,15984,4872,6708,12072,16164,16932,1608,0,0,-6744,11796,5904,0,0,0,0,0,0,0,0,0,0,0,960,0,0,0,0,0,0,0,0,0]
[219,"Hillerød",-305292,0,0,9564,0,-2796,-309840,0,-2424,-12012,33780,-34356,-124104,-12,722940,27684,9228,13836,4212,6648,7920,10620,11124,1056,0,0,-5520,0,0,0,0,0,0,0,0,0,0,0,0,0,3768,0,0,0,19620,0,0,0,0,0]
[223,"Hørsholm",-778020,0,-116376,4332,32832,-1260,-134892,0,-1104,-5844,13464,-15540,-25272,204,327048,12528,4176,6264,1908,2580,5556,7440,7800,744,0,0,-30144,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[230,"Rudersdal",-2055840,0,-333108,9852,106356,-2880,-357480,0,-2508,-13236,32604,-35412,-20772,624,745152,28536,9516,14268,4344,6756,10536,14112,14784,1404,0,0,-69912,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[240,"Egedal",-254472,0,0,7908,0,-2316,-367416,0,-2004,-10164,24300,-28392,16116,660,597396,22872,7620,11436,3480,6480,6264,8388,8796,840,0,0,-4728,0,0,0,0,0,0,0,0,0,0,0,0,0,5652,504,0,0,0,0,0,0,0,0]
[250,"Frederikssund",-75696,0,0,8160,0,-2388,-86136,0,-2076,11844,21336,-29292,46200,84,616416,23604,7872,11796,3600,4752,8664,11616,12168,1164,0,56460,-4452,0,0,0,0,0,0,0,0,0,0,0,0,0,5820,0,0,0,0,0,8184,0,0,0]
[253,"Greve",-125628,0,0,9300,0,-2724,-82140,0,-2364,-396,40788,-33420,36900,756,703272,26928,8976,13464,4104,6888,8052,10788,11304,1080,0,0,-5340,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[259,"Køge",-30900,0,0,10968,0,-3204,42936,924,-2784,98232,36840,-39396,33708,480,828756,31728,10572,33456,16884,7548,9408,12612,13200,1260,0,75912,-5712,0,5904,0,0,0,0,0,0,0,0,0,0,0,7836,0,0,0,0,0,0,0,-6336,0]
[260,"Halsnæs",20016,0,0,5460,0,-1596,38148,816,-1380,85560,14040,-19596,32508,348,412404,15792,5268,16644,8400,2724,6432,8616,9024,864,0,56652,-2916,0,0,0,0,0,0,0,0,0,0,0,0,0,276,0,0,0,0,0,0,0,0,0]
[265,"Roskilde",-586956,0,0,15864,0,-4644,-489816,0,-4032,-20604,46392,-56988,52692,-1044,1199124,45912,15300,22956,6996,9972,13716,18372,19248,1836,0,0,-9444,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[269,"Solrød",-182088,0,0,4296,0,-1260,-174396,0,-1092,-5460,11364,-15432,24840,360,324792,12432,4140,6216,1896,3324,3588,4812,5040,480,0,0,-2532,0,0,0,0,0,0,0,0,0,0,0,0,0,3072,0,0,0,0,0,0,0,0,0]
[270,"Gribskov",-269652,0,0,7224,0,-2112,-69504,0,-1836,-9648,14976,-25956,41472,-24,546060,20904,6972,10452,3180,3828,8724,11700,12252,1164,0,0,-4476,0,0,0,0,0,0,0,0,0,0,0,0,0,5160,0,0,0,0,0,0,0,0,0]
[306,"Odsherred",-18168,0,0,5520,0,-1620,269880,5808,-1404,-7764,10584,-19836,29616,384,417456,15984,5328,16848,8508,2280,7680,10296,10788,1032,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3948,0,0,0,0,0,0,16056,0,0]
[316,"Holbæk",161772,0,0,12900,0,-3768,169524,3648,-3276,-16776,37704,-46368,65136,1080,975492,37356,12456,39372,19884,7896,11940,16008,16764,1596,0,0,0,0,0,0,0,0,11520,0,1152,10764,348,1860,0,516,9216,0,0,0,0,0,0,0,0,0]
[320,"Faxe",154020,0,0,6540,0,-1908,35124,756,-1656,-8604,15540,-23496,31548,552,494436,18936,6312,34392,19968,3672,6360,8520,8928,852,19392,0,0,0,0,0,0,15312,0,0,0,0,0,0,0,0,4668,0,0,0,0,0,0,0,0,0]
[326,"Kalundborg",44520,0,0,8256,0,-2412,348996,7500,-2100,-11388,25356,-29676,-146556,660,624264,23904,7968,25200,12720,4140,8784,11772,12336,1176,48960,0,0,0,0,0,0,0,13632,0,2124,1596,456,0,0,1788,5904,0,0,12720,0,0,0,0,0,0]
[329,"Ringsted",118440,0,0,6288,0,-1836,44040,948,-1596,-8172,22812,-22596,29964,360,475380,18204,6072,33060,19200,4008,4980,6672,6996,660,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4488,0,0,0,0,0,0,21480,0,0]
[330,"Slagelse",432876,14988,0,13896,0,-4068,560160,12048,-3528,-18588,47712,-49932,61476,48,1050648,40224,13404,73080,42432,8148,13284,17796,18636,1776,0,0,0,0,11808,0,0,0,14124,0,1404,2904,0,0,0,876,9924,0,0,0,0,0,0,0,-10872,-31464]
[336,"Stevns",18180,0,0,4080,0,-1188,-1392,0,-1032,12936,8448,-14664,25608,348,308568,11820,3936,5904,1800,2328,4452,5964,6240,600,0,28260,-2088,0,0,0,0,0,0,0,0,0,0,0,0,0,2916,0,0,0,0,0,0,0,0,0]
[340,"Sorø",81084,0,0,5292,0,-1548,42840,924,-1344,-6996,11268,-19020,26808,384,400092,15324,5112,16152,8148,3396,5076,6804,7116,684,15684,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3780,0,0,0,0,0,0,5052,0,0]
[350,"Lejre",-45684,0,0,5136,0,-1500,-152472,0,-1308,-6516,10764,-18468,18204,396,388500,14880,4956,7440,2268,3636,4752,6372,6672,636,0,17796,-2844,0,0,0,0,0,0,0,0,0,0,0,0,0,3672,0,0,0,0,0,0,0,0,0]
[360,"Lolland",213528,8616,0,6684,0,-1956,782148,16824,-1692,22776,19872,-24024,27348,480,505416,19356,6456,35160,20412,2916,8748,11724,12276,1164,59460,0,0,0,0,0,0,15648,24324,0,2688,4788,588,0,0,1236,4776,0,0,0,0,0,0,43272,0,0]
[370,"Næstved",311016,0,0,14664,0,-4284,210312,4524,-3720,-19464,41004,-52692,80688,732,1108620,42444,14148,77112,44772,8532,14016,18792,19680,1872,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10476,0,0,0,0,0,0,0,0,0]
[376,"Guldborgsund",306672,8148,0,10188,0,-2976,599712,12900,-2592,-14256,25620,-36612,40860,708,770208,29496,9828,53568,31104,5184,12048,16140,16908,1608,90624,0,0,0,0,0,0,23844,0,0,0,0,0,0,0,0,7284,0,0,0,0,0,0,0,0,0]
[390,"Vordingborg",154620,0,0,7752,0,-2268,282672,6084,-1968,-10740,19212,-27840,45024,324,585672,22428,7476,40740,23652,3588,9336,12516,13104,1248,68904,0,0,0,0,0,0,18132,0,0,0,0,0,0,0,0,5532,0,0,0,0,0,0,0,-6348,-21384]
[400,"Bornholm",223116,11232,0,6684,0,-1956,158508,3408,-1692,21756,13260,-24000,37560,288,504900,19332,6444,35124,20388,3480,8664,11616,12168,1164,79200,0,0,0,0,0,0,15636,0,59496,0,0,0,0,0,0,4776,0,0,0,0,0,0,0,0,0]
[410,"Middelfart",27732,0,0,6984,0,-2040,-99312,0,-1776,-9048,14808,-25092,18468,228,528060,20220,6744,10116,3084,4476,7236,9696,10152,972,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4992,0,0,0,0,0,0,0,0,0]
[420,"Assens",203988,4128,0,6960,0,-2040,142068,3060,-1764,-9648,13932,-24996,35124,588,525828,20136,6708,36576,21240,3948,7236,9696,10152,972,41244,0,0,0,0,0,0,16284,2820,0,720,576,120,60,0,120,4968,0,0,0,0,0,0,0,0,0]
[430,"Faaborg-Midtfyn",316644,19272,0,9012,0,-2640,83952,1800,-2292,-12156,18300,-32400,47424,672,681576,26100,8700,47412,27528,5472,9732,13044,13656,1296,80196,0,0,0,0,0,0,21108,8520,0,1044,2424,156,228,0,672,6444,0,0,0,0,0,0,0,0,0]
[440,"Kerteminde",51432,0,0,4128,0,-1212,40944,876,-1044,-5568,10632,-14832,16068,336,311952,11940,3984,21696,12600,2448,4728,6324,6624,636,24468,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2880,0,0,0,3600,0,0]
[450,"Nyborg",145332,0,0,5580,0,-1632,141900,3048,-1416,-7524,15060,-20028,30636,468,421452,16140,5376,29316,17028,3048,6072,8136,8520,816,49584,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3984,0,0,0,0,0,0,4884,0,0]
[461,"Odense",1221348,61932,0,36504,0,-10668,132672,2856,-9264,-48072,148152,-131124,124608,408,2758908,105636,35208,191904,111432,23712,27300,36588,38316,3648,0,0,0,0,17724,0,0,0,0,0,0,0,0,0,0,0,26076,0,0,0,0,0,0,0,0,0]
[479,"Svendborg",327156,12156,0,10392,0,-3036,114252,2460,-2640,-13740,23316,-37332,54984,552,785448,30072,10020,54636,31728,6492,11016,14760,15468,1476,92412,0,0,0,0,0,0,0,8784,0,276,564,0,0,0,552,7428,0,0,0,0,0,0,42732,0,0]
[480,"Nordfyn",142548,1548,0,5052,0,-1476,104328,2244,-1284,-6972,11400,-18132,23052,420,381468,14604,4872,26532,15408,2844,5292,7092,7428,708,44880,0,0,0,0,0,0,11808,0,0,0,0,0,0,0,0,3600,0,0,0,0,0,0,0,0,0]
[482,"Langeland",47280,0,0,2052,0,-600,135768,2916,-516,9708,4440,-7356,2052,168,154824,5928,1980,10764,6252,696,3252,4356,4572,432,30360,0,0,0,0,0,0,4788,5016,0,636,492,168,96,0,408,1464,0,0,0,0,0,0,27396,0,0]
[492,"Ærø",45624,4872,0,1008,0,-300,27816,600,-252,10032,1524,-3624,6516,72,76236,2916,972,5304,3084,396,1644,2208,2316,216,14952,0,0,0,0,0,0,2364,1332,61296,10584,35088,2688,624,0,4200,720,0,0,0,0,0,0,0,0,0]
[510,"Haderslev",287916,8040,0,9516,0,-2784,311160,6696,-2412,-13056,31344,-34164,45888,648,718920,27528,9180,50004,29040,5340,9924,13296,13920,1332,84588,0,0,0,0,0,0,0,4740,0,360,1740,0,0,0,132,6792,0,0,0,0,0,0,0,0,0]
[530,"Billund",70464,0,0,4692,0,-1368,48108,1032,-1188,-6252,20988,-16860,-253404,276,354672,13584,4524,24672,14328,2976,4392,5880,6168,588,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3348,0,0,0,0,0,0,0,0,0]
[540,"Sønderborg",283872,0,0,12732,0,-3720,404916,8712,-3228,-9408,48480,-45756,48288,756,962604,36864,12288,66960,38880,6756,14112,18900,19800,1884,75504,0,0,20064,0,0,0,0,0,0,0,0,0,0,1168,0,9096,0,0,0,0,0,0,0,0,0]
[550,"Tønder",217896,12984,0,6240,0,-1824,277980,5976,-1584,-7368,19404,-22428,32736,456,471948,18072,6024,32832,19068,3384,7128,9540,9996,948,55524,0,0,10620,0,0,0,14616,0,0,0,0,0,0,0,0,4464,0,0,0,0,0,0,0,0,0]
[561,"Esbjerg",251496,0,0,19824,0,-5796,344508,7404,-5028,-27084,60156,-71208,28128,888,1498164,57372,19116,104208,60516,12360,18492,24768,25944,2472,0,0,0,0,5904,0,0,0,492,0,108,0,36,0,0,0,14160,0,0,0,0,0,0,0,0,0]
[563,"Fanø",-38460,0,-180,552,0,-168,-11700,0,-144,-684,564,-2004,3504,48,42084,1608,540,804,240,228,876,1164,1224,120,0,0,0,0,0,0,0,0,0,20676,6192,40704,1788,4644,0,0,396,0,0,0,0,0,0,0,0,0]
[573,"Varde",117720,0,0,8496,0,-2484,118632,2556,-2160,-11724,20508,-30504,41388,360,641820,24576,8196,25908,13080,5268,8784,11760,12324,1176,50340,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6072,0,0,0,0,0,0,0,0,0]
[575,"Vejen",149208,0,0,7332,0,-2148,93984,2016,-1860,-10032,23652,-26352,29580,588,554568,21240,7080,38568,22404,4692,6984,9348,9792,936,0,0,0,0,0,0,0,17172,0,0,0,0,0,0,0,0,5244,0,0,0,0,0,0,0,0,0]
[580,"Aabenraa",341832,18384,0,10068,0,-2940,286500,6156,-2556,-13812,29208,-36180,14952,384,761220,29148,9720,52944,30744,5616,10728,14364,15048,1428,59712,0,0,29496,0,0,936,23568,2400,0,216,264,12,0,0,72,7200,0,0,0,0,0,0,0,0,0]
[607,"Fredericia",102516,0,0,9108,0,-2664,318888,6864,-2316,-12084,32784,-32700,-30360,552,688044,26340,8784,27768,14016,5460,8448,11316,11856,1128,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2832,0,0,0,0,0,0,0,0]
[615,"Horsens",513612,13404,0,17100,0,-5004,-14556,0,-4344,18612,62400,-61428,57468,984,1292412,49488,16500,89892,52200,12672,13272,17772,18624,1776,0,0,0,0,0,0,0,0,11220,0,684,732,96,36,0,468,12216,0,0,0,0,0,0,0,0,-22188]
[621,"Kolding",207612,0,0,16584,0,-4848,1572,36,-4212,-21840,69096,-59604,1428,408,1253976,48012,16008,50616,25560,10884,13788,18480,19356,1848,0,0,0,0,5904,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[630,"Vejle",101652,0,0,21264,0,-6216,-62844,0,-5400,-27084,85800,-76392,74892,1188,1607388,61548,20520,64884,32760,15336,17400,23304,24408,2328,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15192,0,0,0,0,0,0,0,0,0]
[657,"Herning",379728,0,0,15516,0,-4536,-126240,0,-3936,-20904,53340,-55740,39924,-2364,1172736,44904,14964,81576,47364,10188,13860,18564,19440,1848,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11088,0,0,0,0,0,0,0,0,-36960]
[661,"Holstebro",314076,10020,0,10200,0,-2988,-108276,0,-2592,-13728,30192,-36648,43476,624,771192,29532,9840,53640,31152,6888,9444,12660,13260,1260,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7284,0,0,0,0,0,0,0,0,0]
[665,"Lemvig",1584,0,0,3204,0,-936,55584,1200,-816,-4644,9192,-11520,-2760,228,242460,9288,3096,9792,4944,1632,3912,5232,5484,528,19020,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2292,0,0,0,0,0,0,0,0,0]
[671,"Struer",90360,0,0,3456,0,-1008,96228,2064,-876,-576,10104,-12420,18840,288,261372,10008,3336,18180,10560,1704,4224,5652,5916,564,30756,0,0,0,0,0,0,8088,4440,0,300,2268,0,0,0,84,2472,0,0,0,0,0,0,0,0,0]
[706,"Syddjurs",138024,0,0,7632,0,-2232,-109212,0,-1932,-10056,13632,-27408,44952,612,576708,22080,7356,23280,11748,5064,8400,11256,11784,1128,45240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5448,0,0,0,0,0,0,0,0,0]
[707,"Norddjurs",223272,13980,0,6300,0,-1848,217080,4668,-1596,-8820,15432,-22644,28200,348,476520,18252,6084,33144,19248,3444,7200,9648,10104,960,56064,0,0,0,0,0,0,14760,9156,0,2436,3732,324,0,0,324,4500,0,0,8820,4932,0,0,22548,0,0]
[710,"Favrskov",117504,0,0,8532,0,-2496,-289728,0,-2160,-11352,20388,-30660,32424,576,644952,24696,8232,12348,3768,6852,6984,9360,9792,936,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6096,0,0,0,0,0,0,0,0,0]
[727,"Odder",48876,0,0,4188,0,-1224,-70656,0,-1068,-5340,8988,-15036,24456,348,316392,12120,4044,6060,1848,2868,4416,5916,6192,588,0,0,0,0,0,0,0,0,3684,0,744,1836,96,0,0,168,2988,0,0,0,0,0,0,0,0,0]
[730,"Randers",629976,42300,0,17388,0,-5088,388008,8340,-4416,-22992,46500,-62496,73596,792,1314780,50340,16776,91452,53100,11604,15468,20736,21708,2064,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10320,0,0,0,0,0,0,0,0,0]
[740,"Silkeborg",260220,0,0,17724,0,-5184,-416880,0,-4500,-21924,42828,-63684,49380,1188,1339968,51312,17100,25656,7812,14460,14724,19728,20664,1968,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12660,0,0,0,0,0,0,0,0,0]
[741,"Samsø",6072,0,0,624,0,-180,11076,240,-156,-864,1008,-2268,3888,48,47592,1824,612,1920,972,300,984,1320,1392,132,5604,0,0,0,0,0,0,0,0,60384,8940,29652,1812,3252,0,1104,444,0,0,0,0,0,0,0,0,0]
[746,"Skanderborg",18096,0,0,11400,0,-3336,-465084,0,-2892,-14664,24132,-40980,33444,900,862164,33012,11004,16512,5028,9780,8964,12012,12576,1200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8148,0,0,0,0,0,0,0,0,0]
[751,"Århus",849612,0,0,65028,0,-19020,-1875252,0,-16512,-81684,260640,-233640,-11772,-9132,4915728,188232,62748,94116,28668,42732,40500,54264,56832,5424,0,0,0,0,17712,0,0,0,0,0,0,0,0,0,0,0,6600,0,0,0,0,0,0,0,0,0]
[756,"Ikast-Brande",300672,26352,0,7452,0,-2184,16080,348,-1896,-9684,31080,-26760,3588,588,563028,21564,7188,39168,22740,5052,6528,8748,9168,876,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5316,0,0,0,0,0,0,0,0,0]
[760,"Ringkøbing-Skjern",151008,0,0,9528,0,-2784,30312,648,-2424,-13308,29880,-34248,5736,588,720480,27588,9192,50112,29100,5688,9936,13320,13944,1332,28260,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6804,0,0,0,0,0,0,0,0,0]
[766,"Hedensted",194184,0,0,8340,0,-2436,-177384,0,-2124,-10944,18816,-29976,14232,552,630744,24156,8052,25464,12852,5652,7428,9960,10428,996,0,0,0,0,0,0,0,0,3228,0,168,816,0,108,0,132,5964,0,0,0,0,0,0,0,0,0]
[773,"Morsø",122256,8472,0,3336,0,-972,146112,3144,-852,23148,7152,-11988,12648,276,252336,9660,3216,17556,10188,1800,4008,5364,5616,540,29688,0,0,0,0,0,0,7812,0,0,0,0,0,0,0,0,2388,0,0,0,0,0,0,0,0,0]
[779,"Skive",198744,0,0,7584,0,-2220,220716,4752,-1920,18384,18984,-27252,27420,444,573480,21960,7320,39888,23160,4020,8460,11328,11868,1128,67476,0,0,0,0,0,0,17760,8196,0,1092,4464,228,852,434,336,5424,0,0,0,0,0,0,0,0,0]
[787,"Thisted",258612,15960,0,7332,0,-2148,149544,3216,-1860,-10188,17640,-26352,27900,420,554364,21228,7080,38556,22392,4440,7908,10608,11100,1056,43488,0,0,0,0,0,0,17160,0,0,0,0,0,0,0,0,5244,0,0,0,0,0,0,0,0,0]
[791,"Viborg",438588,0,0,16824,0,-4920,-39132,0,-4272,-22824,48192,-60420,48468,-492,1271340,48684,16224,88428,51348,10356,15588,20892,21876,2088,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12012,0,0,0,0,0,0,0,0,0]
[810,"Brønderslev",276372,27948,0,6336,0,-1848,69840,1500,-1608,-8532,16896,-22752,33060,360,478620,18324,6108,33288,19332,4380,6228,8340,8736,828,56316,0,0,0,0,0,0,14820,0,0,0,0,0,0,0,0,4524,0,0,0,0,0,0,31668,0,0]
[813,"Frederikshavn",234816,0,0,9924,0,-2904,352860,7584,-2520,24468,22092,-35628,35340,396,749724,28704,9564,52152,30288,5004,12120,16236,17004,1620,88212,0,0,0,0,0,0,23208,0,0,0,0,0,0,0,0,7080,0,0,0,0,0,0,0,0,0]
[820,"Vesthimmerland",199368,8772,0,6144,0,-1800,232092,4992,-1560,-8664,18444,-22068,24216,516,464292,17772,5928,32292,18756,3288,6732,9024,9444,900,54624,0,0,0,0,0,0,14376,0,0,0,0,0,0,898,0,4392,0,0,0,0,0,0,38304,0,0]
[825,"Læsø",2760,0,0,300,0,-84,13512,288,-72,204,216,-1056,1800,24,22212,852,288,900,456,108,528,708,744,72,2616,0,0,0,0,0,0,0,0,53052,3552,15888,732,1644,0,2532,204,0,0,0,0,0,0,552,0,0]
[840,"Rebild",89256,0,0,5340,0,-1560,-129564,0,-1356,-7056,10968,-19176,25344,444,403368,15444,5148,28056,16296,4272,4644,6216,6516,624,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3816,0,0,0,0,0,0,0,0,-13116]
[846,"Mariagerfjord",203040,2376,0,7164,0,-2100,91692,1968,-1824,-9840,19020,-25740,18564,588,541512,20736,6912,37668,21876,4236,7488,10032,10500,996,21240,0,0,0,0,0,0,16764,0,0,0,0,0,0,0,0,5112,0,0,0,0,0,0,0,0,0]
[849,"Jammerbugt",197616,5568,0,6528,0,-1908,77340,1668,-1656,-9000,12672,-23436,37068,516,492996,18876,6288,34296,19908,3804,7080,9492,9936,948,38664,0,0,0,0,0,0,15264,0,0,0,0,0,0,0,0,4656,0,0,0,0,0,0,0,0,0]
[851,"Aalborg",1128684,19884,0,38892,0,-11376,-560100,0,-9876,-50688,119784,-139752,21504,396,2940240,112584,37524,204516,118752,24792,29868,40008,41904,3996,0,0,0,0,0,0,0,0,2568,0,180,216,48,0,0,84,2484,0,0,0,0,0,0,0,0,-34260]
[860,"Hjørring",336636,11328,0,10860,0,-3180,233832,5028,-2760,15144,26436,-39000,3972,312,820536,31416,10476,57072,33144,6216,11940,15984,16752,1596,96540,0,0,0,0,0,0,25404,0,0,0,0,0,0,0,0,7752,0,0,0,0,0,0,0,0,0]

{"sheet":"Bilag 2 ","index":2,"n_rows":115,"n_cols":14,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Bilagstabel 2: Grunddata til statsgaranti \"&aar","v":"Bilagstabel 2: Grunddata til statsgaranti 2026"},null,null,null," ",null,"lukkes sammen"]
[]
["knr","kommunenavn"," Udskriv-"," Indkomst-"," Udskriv-"," Grund-"," Grund-"," Grund-","Beregnings-","Beregnings-"," Beskat-"," Udgifts-"," Samlet"," Udgifts-"]
[null,null," nings-"," skat"," nings-"," skylds-"," skylds-"," skylds-","tekniske","tekniske"," nings-"," behov"," antal"," behov"]
[null,null," procent",null," grundlag"," promille,"," promille,"," provenu"," grund-"," grund-"," grundlag",null," indbyg-"," pr."]
[null,null,null,null,null," øvrige"," produk-",null," værdier,"," værdier,",null,null," gere"," indbygger"]
[null,null,null,null,null," ejen-"," tions-",null," øvrige"," produk-",null,null," (IM-"]
[null,null,null,null,null," domme"," jord",null," ejen-"," tions-",null,null," skøn)"]
[null,null,null,null,null,null,null,null," domme"," jord"]
[null,null,null,null," ","Anvendes ","Anvendes ","Anvendes "," "]
[null,null,null,null," ","ikke","ikke","ikke"," "]
[null,null,null,null," ","i 2024","i 2024","i 2024"," "]
[]
[null,null,1,{"$f":"+C14+1","v":2},3,4,5,6,7,8,9,10,11,12]
[]
[1,"Kommuner i alt ",{"$f":"100*D16/E16","v":25.069097693206562},{"$f":"SUM(D18:D115)","v":344522488},{"$f":"SUM(E18:E115)","v":1374291537},"---","---",{"$f":"SUM(H18:H115)","v":0},1182226121,124605937.99999996,1493932781,489968299.99999946,6020396,{"$f":"+L16/M16*1000","v":81384.729509487326}]
[]
[101,"København",23.5,38584565,164189638,0,0,0,132008284,0,177136362,51553001.811196998,672681,76638.111989482393]
[147,"Frederiksberg",24.57,7626838,31041262,0,0,0,21426655,0,33142683,7525866.1439335803,105899,71066.451467280902]
[151,"Ballerup",25.5,3007693,11794875,0,0,0,15631822,11820,13328318,4772093.4471461298,53602,89028.272212718497]
[153,"Brøndby",24.3,1839243,7568901,0,0,0,8372203,936,8390033,3999199.96419279,41309,96811.831905705607]
[155,"Dragør",24.8,1052228,4242855,0,0,0,6197219,19293,4851220,1090621.1179671299,14374,75874.573394123901]
[157,"Gentofte",24.239999999999899,8850962,36513870,0,0,0,42457338,0,40677877,5525317.7719114004,74897,73772.217470812]
[159,"Gladsaxe",23.599999999999898,4122358,17467619,0,0,0,21518649,119,19578066,5922647.1706608003,71259,83114.373912920506]
[161,"Glostrup",24.6,1349996,5487789,0,0,0,6262503,1368,6102025,2155640.3689423199,25069,85988.287085337404]
[163,"Herlev",23.6999999999999,1596274,6735333,0,0,0,7698941,4328,7490536,2734415.4084413699,31103,87914.8444986455]
[165,"Albertslund",25.6,1436899.99999999,5612891,0,0,0,6728602,20610,6273410,2710038.6354955202,28201,96097.253129163]
[167,"Hvidovre",25.4,3055051,12027760,0,0,0,13809902,2453,13382240,4683271.2453546496,53892,86901.047379103693]
[169,"Høje-Taastrup",24.6,2934933,11930622,0,0,0,12610023,161303,13172133,5161012.2402409697,60272,85628.687288309302]
[173,"Lyngby-Taarbæk",24.3799999999999,4791585,19653753,0,0,0,26555423,8171,22258421,4350535.57306924,58992,73747.890782974704]
[175,"Rødovre",25.6999999999999,2518134,9798187,0,0,0,10074410,0,10786236,3966339.0808290602,45402,87360.448456655402]
[183,"Ishøj",25,1157811,4631244,0,0,0,4287181,50707,5053213,2383035.4407995101,24558,97037.032364179395]
[185,"Tårnby",24.1,2417203,10029888,0,0,0,12666005,10652,11272423,3732712.1371719702,44286,84286.504474821995]
[187,"Vallensbæk",25.6,1039635,4061074,0,0,0,4610946,714,4513314,1451614.8090943701,18523,78368.234578328294]
[190,"Furesø",24.88,3144797,12639859,0,0,0,16137148,88540,14225136,3337248.1353382901,42809,77956.694511394599]
[201,"Allerød",25.3,1906369,7535055,0,0,0,9976654,128282,8517320,1883116.2382489899,26102,72144.519126848405]
[210,"Fredensborg",25.3,2780507,10990146,0,0,0,13889655,275979,12360557,3414791.1985174799,42389,80558.427859054995]
[217,"Helsingør",25.82,4057111,15713055.999999899,0,0,0,22808384,304240,17959010,5333414.5488042301,64155,83133.263951433793]
[219,"Hillerød",25.6,3522018,13757883,0,0,0,16661372,564940,15408698,4187928.9586073202,55552,75387.546057879401]
[223,"Hørsholm",23.6999999999999,2128243,8979928,0,0,0,14204042,38981,10374146,1900229.3419653999,25131,75612.961758998907]
[230,"Rudersdal",23.52,5102574,21694617,0,0,0,35135145,78036,25142813,4275626.2365929298,57259,74671.688932620702]
[240,"Egedal",25.6999999999999,2940728,11442521,0,0,0,13172216,342550,12744543,3340890.1295543802,45905,72778.349407567395]
[250,"Frederikssund",25.6999999999999,2828993,11007755,0,0,0,11475412,786532,12156526,3762334.5421061902,47367,79429.445438938303]
[253,"Greve",24.59,3066069,12468764,0,0,0,16375847,113857,14078202,4309793.76298868,54041,79750.444347600598]
[259,"Køge",25.26,3661176,14493967,0,0,0,14819581,669004,15967233,5229067.2106967103,63684,82109.591274051796]
[260,"Halsnæs",25.6999999999999,1790258,6965984,0,0,0,7984125,277879,7757266,2620104.7308936599,31690,82679.227860323794]
[265,"Roskilde",25.2,5888285,23366210,0,0,0,26538407,605333,25986914,6972434.8936818903,92144,75668.897526500805]
[269,"Solrød",24.99,1577955.99999999,6314350,0,0,0,8605760,112516,7161697,1843682.42393552,24958,73871.400910951401]
[270,"Gribskov",25.4,2531142,9965126,0,0,0,18954815,758061,11846596,3340255.4786074599,41961,79603.810171527395]
[306,"Odsherred",26.3,1819646,6918806,0,0,0,11339445,868081,8056660,2900853.0146683902,32078,90431.230583839002]
[316,"Holbæk",25.3,4186419,16547111,0,0,0,11656705,1686300,17740339,6282807.0983318305,74959,83816.581042060803]
[320,"Faxe",25.8,2080672,8064620,0,0,0,5144952,1336092,8608824,3129893.56314279,37994,82378.627234373693]
[326,"Kalundborg",24.2,2637773,10899888,0,0,0,7289849,1749871,11666721,4279287.5567872701,47970,89207.578836507702]
[329,"Ringsted",26.1,2046297,7840218,0,0,0,5793570,882440,8434585,3020254.4410973601,36529,82681.005258763398]
[330,"Slagelse",26.1,4323343,16564533,0,0,0,11331784,1874554,17731475,7172832.3712277301,80734,88845.249476400699]
[336,"Stevns",26,1383981,5323004,0,0,0,4434597,982665,5787062,1928219.2633593499,23711,81321.718331548793]
[340,"Sorø",26.3,1770965,6733706.9999999898,0,0,0,4460891,893667,7197705,2548155.14992342,30744,82883.006437790202]
[350,"Lejre",25.31,1767923,6985077,0,0,0,6544236,808525,7650875,2265634.3269146699,29853,75893.020028629398]
[360,"Lolland",26.3,2131432,8104304,0,0,0,2955685,3620763,8501531,4001751.7980243,38837,103039.673456351]
[370,"Næstved",25,4527682,18110728,0,0,0,13371496,2122901,19485078,7159229.0502342703,85189,84039.360131405003]
[376,"Guldborgsund",25.8,3159294,12245326,0,0,0,7209215,3475099,13055400,5461607.3805278204,59185,92280.2632512938]
[390,"Vordingborg",26.3,2546654,9683095,0,0,0,6141891,2013109,10345146,3966581.0820867098,45004,88138.411743105302]
[400,"Bornholms",26.2,2077934,7931046,0,0,0,4904716,970529,8440851,3328002.9178210301,38798,85777.692608408397]
[410,"Middelfart",25.8,2404599,9320151,0,0,0,5779330,1163937,9921468,3195563.6410464002,40577,78753.077877773103]
[420,"Assens",26.1,2210961,8471115,0,0,0,4196839,1987443.99999999,8941644,3441188.50837817,40406,85165.285066034194]
[430,"Faaborg-Midtfyn",26.1,2772344,10622008,0,0,0,6265329,2554774,11312225,4352708.2459325399,52374,83108.188145502398]
[440,"Kerteminde",26.1,1377347,5277192,0,0,0,3805912,818783,5674732,1994900.62895197,23971,83221.418753993203]
[450,"Nyborg",26.3,1786915,6794354,0,0,0,4417960,1198777,7263187,2788220.5738216499,32385,86096.049832380901]
[461,"Odense",25.5,10948813,42936522,0,0,0,32135811,771303,46111112,17396307.619525999,212001,82057.667744614402]
[479,"Svendborg",26.3,3217103,12232331,0,0,0,9753687,1621874,13237010,5034911.9633361101,60356,83420.239302407703]
[480,"Nordfyn",26,1580633,6079358,0,0,0,3877350,1891800,6515717,2497810.0934563298,29313,85211.684012429294]
[482,"Langeland",26.3,654752,2489551,0,0,0,1768940,1271816,2700747,1114222.7352438699,11897,93655.773324692898]
[492,"Ærø",26.1,298710,1144483,0,0,0,586513,303567,1211005,506657.33390892402,5858,86489.814596948607]
[510,"Haderslev",26.3,3017717,11474209,0,0,0,6132166,3427505,12177240,4830592.09647837,55244,87441.027016117194]
[530,"Billund",24,1436113,5983804,0,0,0,3737937,1273421,6388157,2269789.0745268199,27254,83282.786912997006]
[540,"Sønderborg",25.6999999999999,4069812,15835844,0,0,0,9600788,2287215,16845253,6455337.1284980504,73969,87270.844928254504]
[550,"Tønder",25.3,1868999,7387348,0,0,0,3498354,3707101,7840357,3250402.9734710599,36266,89626.729539267297]
[561,"Esbjerg",26.1,6634355,25418985,0,0,0,17785115,2238990,27229643,9739688.4719276,115123,84602.455390561401]
[563,"Fanø",26.1,206707,791981,0,0,0,2186239,22904,1007076,250616.07326853101,3234,77494.147578395699]
[573,"Varde",25.099999999999898,2644539,10536012,0,0,0,9927668,3456996,11612162,4141380.9278634,49319,83971.307769082894]
[575,"Vejen",25.8,2402231,9310973,0,0,0,3910209,2915100,9780894,3569183.9532287698,42614,83756.135383413202]
[580,"Aabenraa",25.6,3046614,11900836,0,0,0,7214644,2986052,12696943,5068585.8523466904,58494,86651.380523586893]
[607,"Fredericia",25.5,2966790,11634471,0,0,0,9451239,440012,12574448,4645788.2382753296,52871,87870.2547384262]
[615,"Horsens",25.69,5269946,20513608,0,0,0,13748531,1689986,21912101,8066822.4634712003,99312,81227.066854672201]
[621,"Kolding",25.5,5358782,21014831,0,0,0,17469777,2652146,22806812,7843838.7127354704,96359,81402.242787238007]
[630,"Vejle",23.4,6512928,27833026,0,0,0,22195038,3353700,30109237,9984745.1941560507,123516,80837.666327893196]
[657,"Herning",25.4,4815163,18957335,0,0,0,13137227,3252387,20342196,7198324.9035272896,90116,79878.433391709405]
[661,"Holstebro",25.5,3124646,12253514,0,0,0,7329440,2100889,13034637,4706438.8512540404,59260,79420.162862876197]
[665,"Lemvig",25.6999999999999,1131484,4402661,0,0,0,1645281,1712747,4614802,1576051.91115212,18631,84592.985408841705]
[671,"Struer",25.3,1084749,4287545,0,0,0,1897071,995942,4503128,1738000.2365421101,20084,86536.558282319995]
[706,"Syddjurs",25.9,2407570,9295637,0,0,0,9244060,2038179,10262677,3489213.8172130198,44316,78734.854617136603]
[707,"Norddjurs",26,1936969,7449881,0,0,0,3908604,2212838,7898824,3213480.39409546,36617,87759.248275267295]
[710,"Favrskov",25.6999999999999,2791698,10862638,0,0,0,7642476,2055868,11673127,3721896.7428474501,49560,75098.804335098001]
[727,"Odder",25.099999999999898,1302183,5187980,0,0,0,5649423.9999999898,1042236,5772948,1902653.6511846499,24312,78259.857320856099]
[730,"Randers",26,5335485,20521096,0,0,0,11385214,2767661,21719757,8639597.5897358898,101031,85514.323224909996]
[740,"Silkeborg",25.5,5674993,22254875,0,0,0,18863974,2076741,24166532,7931595.6208589701,102966,77031.210505011099]
[741,"Samsø",25.9,204358,789027,0,0,0,756561.99999999895,403716,875196,309527.15063796402,3657,84639.636488368706]
[746,"Skanderborg",26,3918040,15069385,0,0,0,12567593,1405778,16343631,4891727.7858186997,66251,73836.286030681906]
[751,"Århus",24.52,20005020,81586542,0,0,0,77350334,1415159,89214640,28725547.921365999,377736,76046.624948021999]
[756,"Ikast-Brande",25.099999999999898,2154381,8583191,0,0,0,5158663,1600979.99999999,9136593,3538314.8593504899,43264,81784.274670638406]
[760,"Ringkøbing-Skjern",25,2986678,11946712,0,0,0,9228444,2803037,12934897,4538300.1014250098,55363,81973.522053086199]
[766,"Hedensted",25.52,2638228,10337884,0,0,0,6394820,986087,10994292,3753813.36615542,48468,77449.314313679497]
[773,"Morsø",25.8,1033415,4005484,0,0,0,1363031,747729,4161332,1735160.8453633899,19390,89487.408218844794]
[779,"Skive",25.5,2407906,9442769,0,0,0,4024762,1374147,9878239,3823793.5821561301,44068,86770.300039850699]
[787,"Thisted",25.5,2225283,8726600,0,0,0,3933428,2797415,9195309,3627710.1965346201,42599,85159.515400235396]
[791,"Viborg",25.5,5251987,20596027,0,0,0,12210739,3905083,21909374,7908645.1162518896,97693,80954.061358049003]
[810,"Brønderslev",26.3,1928635,7333213,0,0,0,2781799,1696947.99999999,7656349,3068266.8472163999,36778,83426.691152765299]
[813,"Frederikshavn",26.2,3197394,12203794,0,0,0,8249565,1150656,13046985,5068073.0463789199,57611,87970.579340384997]
[820,"Vesthimmerland",26.3,1961927,7459798,0,0,0,2868829,1738768,7792710,3153119.9556835298,35677,88379.6270898207]
[825,"Læsø",26.3,95608,363528.99999999901,0,0,0,437688.99999999901,83221,408923,153448.57345445399,1707,89893.716142035395]
[840,"Rebild",25.83,1772859,6863566,0,0,0,3109620,1627282,7216788,2383282.4704840798,30996,76890.000983484293]
[846,"Mariagerfjord",25.9,2278918,8798911,0,0,0,4057015,1648246,9245670,3485098.5135964402,41611,83754.260017698398]
[849,"Jammerbugt",25.6999999999999,1975442,7686545,0,0,0,6249708,1684333,8349423,3166262.0687092501,37883,83580.024515198194]
[851,"Aalborg",25.6,12015363,46935012,0,0,0,31188693,2285809,50061615,17785402.450392701,225935,78719.111471851196]
[860,"Hjørring",26.21,3410746,13013148,0,0,0,7912979,2239053,13855598,5382899.7156298701,63052,85372.386532225501]

{"sheet":"Bilag 3","index":3,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Bilagstabel 3: Parametre til statsgaranti \"&aar","v":"Bilagstabel 3: Parametre til statsgaranti 2026"}]
[]
[null,null," Folketal "," Parametre,"]
[null,null,"bloktilskud","udlignings-"]
[null,null,"mv.","procenter"]
[null,null,null,"mv."]
[]
[null,null,"(1)","(2)"]
[]
[null,"01. Statstilskud ordinært                                                     ",78347301,0]
[null,"02. Betinget statstilskud service                                     ",3000000,0,null,null,null,0]
[null,"03. Betinget statstilskud anlæg                                         ",1000000,0]
[null,"04. Andre tilskud                                                                     ",965599,0]
[null,"05. Tilskud ialt (1+2+3+4)                                                   ",83312900,0]
[null,"06. Samlet udskrivningsgrundlag                                         ",1374291537,0]
[null,"07. Beregningsteknisk grundværdi vedr. produkionsjord                                 ",124605938,0]
[null,"08. Indregning vedr. produktionsjord                               ",3694311,2.9647971182824001E-2]
[null,"09. Beregningsteknisk grundværdi vedr. øvrige ejendomme                             ",1182226121,0]
[null,"10. Indregning vedr. øvrige ejendomme                             ",115946933,9.8075090133096995E-2]
[null,"11. Samlet beskatningsgrundlag (6+8+10)                         ",1493932781,0]
[null,"12. Samlet udskrivning                                                           ",374515469,0]
[null,"13. Beskatningsniveau (12/11)                                             ",0,0.25069097737403501]
[null,"14. Samlet folketal                                                                 ",6020396,0]
[null,"15. Beskatningsgrundlag pr. indbygger (kroner)           ",248145.26835111799,0]
[null,"16. Grænse vedr. lavt beskatningsgrundlag (kroner)  ",223330.741516006,0.9]
[null,"17. Grænse vedr. højt beskatningsgrundlag (kroner)  ",310181.58543889801,1.25]
[null,"18. Udligningsprocent beskatningsgrundlag (generel) ",0,0.75]
[null,"19. Udligningsprocent lavt beskatningsgrundlag           ",0,0.2]
[null,"20. Udligningsprocent højt beskatningsgrundlag           ",0,0.18]
[null,"21. Overudligningsgrænse  (bruges ikke)                                                     ",0,0.93]
[null,"22. Bund vedr. udskrivningsprocent i overudligning  (bruges ikke)",0,0.23250000000000001]
[null,"23. Nettodrifts- og anlægsudgifter (udgiftsbehov)     ",489968300,0]
[null,"24. Samlet folketal                                                                 ",6020396,0]
[null,"25. Udgiftsbehov pr. indbygger (23/24)  (kroner)        ",81384.729509487399,0]
[null,"26. Udligningsprocent udgiftsbehov (generel)               ",0,0.93]
[null,"27. Udligningsprocent udgiftsbehov over gennemsnit  ",0,0.02]
[null,"28. Samlet tilskud vedr. indvandrer og efterkommer  ",3723756,0]
[null,"29. Samlet bidrag vedr. indvandrer og efterkommer     ",-3723756,0]
[null,"30. Tilskudår",2026,0]
[null,"31. Korrektion vedr. overudligning                                     ",-303108,0]
[null,"32. Finansiering af tillæg vedr. beskatningsgrundlag ",1036464,0]
[null,"33. Finansiering af tillæg vedr. udgiftsbehov               ",-263124,0]

{"sheet":"Makro mv.","index":4,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Bilagstabel til validering af kommunenummer og data"]
[null,"Gyldigt ","Kommune navn"]
[null,"komnr"]
[null,"(ok=1)"]
["Bilagstabel 1",{"$f":"IF((TYPE(VLOOKUP(knr,Bilagtab1,2,FALSE)))=16,0,1)","v":0},{"$f":"IF(B5=1,VLOOKUP(knr,Bilagtab1,2),0)","v":0}]
["Bilagstabel 2",{"$f":"IF((TYPE(VLOOKUP(knr,Bilagtab2,2,FALSE)))=16,0,1)","v":0},{"$f":"IF(B6=1,VLOOKUP(knr,Bilagtab2,2),0)","v":0}]
["OK bilag 1 og 2",{"$f":"IF(2=B5+B6,1,0)","v":0}]
["OK som Primkommune",{"$f":"IF(AND(1=B7,C8>0),1,0)","v":0},{"$f":"IF(B7=1,VLOOKUP(knr,Bilagtab1,1),\"xx\")","v":"xx"}]
[]
["Tilskudsår:/ AAR",{"$f":"TEXT('Bilag 3'!C39,0)","v":"2026"}]
[]
[null,"kom"]
["Kommunen/amtes  data er udfyldt",{"$f":"IF(4=SUM(B14:B17),1,0)","v":0}]
[{"$f":"\"1.01 Budgetteret indkomstskat \"&aar","v":"1.01 Budgetteret indkomstskat 2026"},{"$f":"IF(0<>+Selvbudgettering!F24,1,0)","v":0}]
[{"$f":"\"1.02 Udskrivningsprocent \"&aar","v":"1.02 Udskrivningsprocent 2026"},{"$f":"IF(0<>+Selvbudgettering!F25,1,0)","v":0}]
[{"$f":"\"1.03 Grundværdier/grundskyld \"&aar","v":"1.03 Grundværdier/grundskyld 2026"},{"$f":"IF(0<>+Selvbudgettering!F26,1,0)","v":1}]
[{"$f":"\"1.05 Skønnet folketal pr. 1. janual \"&aar","v":"1.05 Skønnet folketal pr. 1. janual 2026"},{"$f":"IF(0<>+Selvbudgettering!F28,1,0)","v":0}]
[]
["Kommunens data er udfyldt og komnr ok",{"$f":"IF(+B13+B8=2,1,0)","v":0}]